package com.geping.etl.common.service;


import java.util.List;

import com.geping.etl.common.entity.Sys_Department;
import com.geping.etl.common.entity.Sys_DepartmentVo;


public interface Sys_DepartmentService {

	
	//查询所有未删除的部门
	public List<Sys_Department> findAllSys_Department();
	
	//根据用户名查询部门信息
	public List<Sys_Department> getSys_DepartmentByLikeDepartmentName(String departmentName);
	
	//插入
	public Sys_Department save(Sys_Department sys_Department);
	
	//获取最大ID数
	public Integer findMaxId();
	
	//修改部门信息
    public int updateSys_Department(Integer id_edit,String departmentName,String description, String departmentId);
    
    //逻辑删除部门
    public int deleteSys_Department(Integer id);

	//设置部门ID
	public int updateDepartmentId(Integer id,String departmentId);

	/**
	 * 新增部门
	 * @param sys_Department
	 * @return
	 */
	Sys_Department saveDept(Sys_Department sys_Department);

	//根据部门名称查询部门信息
	List<Sys_Department> getSys_DepartmentByDepartmentName(String departmentName);

	//根据部门Id查询部门信息
	List<Sys_Department> getSys_DepartmentByLikeDepartmentIdAndDepartmentName(String departmentId,String departmentName);

	//根据描述查询部门信息
	List<Sys_Department> getSys_DepartmentByDescriptionAndDepartmentName(String description, String departmentName);

	List<Sys_Department> getSys_DepartmentByLikeDescription(String departmentName);

	Sys_DepartmentVo getSysDeptVoBySysDept(Sys_Department sysDepartment);

	Sys_Department getSys_DepartmentById(Integer id);
}
